Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 840 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 92.0 KiB |
| Average record size in memory | 112.2 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 1 |
Año is highly overall correlated with 20 - 30 Mbps and 2 other fields | High correlation |
1 - 6 Mbps is highly overall correlated with Total and 1 other fields | High correlation |
6 - 10 Mbps is highly overall correlated with 10 - 20 Mbps and 4 other fields | High correlation |
10 - 20 Mbps is highly overall correlated with 6 - 10 Mbps and 4 other fields | High correlation |
20 - 30 Mbps is highly overall correlated with Año and 6 other fields | High correlation |
>=30 Mbps is highly overall correlated with Año and 6 other fields | High correlation |
Otros is highly overall correlated with Año and 2 other fields | High correlation |
Total is highly overall correlated with 1 - 6 Mbps and 5 other fields | High correlation |
Total2 is highly overall correlated with 1 - 6 Mbps and 5 other fields | High correlation |
id_Provincia has 35 (4.2%) zeros | Zeros |
0.512 - 1 Mbps has 50 (6.0%) zeros | Zeros |
6 - 10 Mbps has 38 (4.5%) zeros | Zeros |
10 - 20 Mbps has 71 (8.5%) zeros | Zeros |
20 - 30 Mbps has 104 (12.4%) zeros | Zeros |
>=30 Mbps has 112 (13.3%) zeros | Zeros |
Otros has 455 (54.2%) zeros | Zeros |
Diferencia has 40 (4.8%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-16 22:58:17.072840 |
|---|---|
| Analysis finished | 2023-07-16 22:58:39.907975 |
| Duration | 22.84 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
Año
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2017.8857 |
| Minimum | 2014 |
|---|---|
| Maximum | 2022 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 2014 |
|---|---|
| 5-th percentile | 2014 |
| Q1 | 2016 |
| median | 2018 |
| Q3 | 2020 |
| 95-th percentile | 2022 |
| Maximum | 2022 |
| Range | 8 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.528745 |
|---|---|
| Coefficient of variation (CV) | 0.0012531656 |
| Kurtosis | -1.2039979 |
| Mean | 2017.8857 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.022512286 |
| Sum | 1695024 |
| Variance | 6.3945513 |
| Monotonicity | Decreasing |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 2021 | 96 | |
| 2020 | 96 | |
| 2019 | 96 | |
| 2018 | 96 | |
| 2017 | 96 | |
| 2016 | 96 | |
| 2015 | 96 | |
| 2014 | 96 | |
| 2022 | 72 |
| Value | Count | Frequency (%) |
| 2014 | 96 | |
| 2015 | 96 | |
| 2016 | 96 | |
| 2017 | 96 | |
| 2018 | 96 | |
| 2019 | 96 | |
| 2020 | 96 | |
| 2021 | 96 | |
| 2022 | 72 |
| Value | Count | Frequency (%) |
| 2022 | 72 | |
| 2021 | 96 | |
| 2020 | 96 | |
| 2019 | 96 | |
| 2018 | 96 | |
| 2017 | 96 | |
| 2016 | 96 | |
| 2015 | 96 | |
| 2014 | 96 |
Trimestre
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.7 KiB |
| 3 | |
|---|---|
| 2 | |
| 1 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 840 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 840 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 840 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 840 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 216 | |
| 2 | 216 | |
| 1 | 216 | |
| 4 | 192 |
id_Provincia
Real number (ℝ)
ZEROS
| Distinct | 24 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.5 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 35 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5.75 |
| median | 11.5 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 11.5 |
Descriptive statistics
| Standard deviation | 6.9263106 |
|---|---|
| Coefficient of variation (CV) | 0.60228788 |
| Kurtosis | -1.2041954 |
| Mean | 11.5 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0 |
| Sum | 9660 |
| Variance | 47.973778 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 0 | 35 | 4.2% |
| 1 | 35 | 4.2% |
| 22 | 35 | 4.2% |
| 21 | 35 | 4.2% |
| 20 | 35 | 4.2% |
| 19 | 35 | 4.2% |
| 18 | 35 | 4.2% |
| 17 | 35 | 4.2% |
| 16 | 35 | 4.2% |
| 15 | 35 | 4.2% |
| Other values (14) | 490 |
| Value | Count | Frequency (%) |
| 0 | 35 | |
| 1 | 35 | |
| 2 | 35 | |
| 3 | 35 | |
| 4 | 35 | |
| 5 | 35 | |
| 6 | 35 | |
| 7 | 35 | |
| 8 | 35 | |
| 9 | 35 |
| Value | Count | Frequency (%) |
| 23 | 35 | |
| 22 | 35 | |
| 21 | 35 | |
| 20 | 35 | |
| 19 | 35 | |
| 18 | 35 | |
| 17 | 35 | |
| 16 | 35 | |
| 15 | 35 | |
| 14 | 35 |
<0.512 mbps
Real number (ℝ)
| Distinct | 371 |
|---|---|
| Distinct (%) | 44.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2898.4405 |
| Minimum | 60 |
|---|---|
| Maximum | 199768 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 60 |
|---|---|
| 5-th percentile | 90 |
| Q1 | 320 |
| median | 1050 |
| Q3 | 2565.75 |
| 95-th percentile | 7452.4 |
| Maximum | 199768 |
| Range | 199708 |
| Interquartile range (IQR) | 2245.75 |
Descriptive statistics
| Standard deviation | 10900.555 |
|---|---|
| Coefficient of variation (CV) | 3.7608344 |
| Kurtosis | 206.75317 |
| Mean | 2898.4405 |
| Median Absolute Deviation (MAD) | 850 |
| Skewness | 13.299608 |
| Sum | 2434690 |
| Variance | 1.1882209 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 90 | 20 | 2.4% |
| 150 | 16 | 1.9% |
| 180 | 16 | 1.9% |
| 100 | 15 | 1.8% |
| 160 | 15 | 1.8% |
| 670 | 14 | 1.7% |
| 710 | 12 | 1.4% |
| 80 | 12 | 1.4% |
| 260 | 11 | 1.3% |
| 60 | 11 | 1.3% |
| Other values (361) | 698 |
| Value | Count | Frequency (%) |
| 60 | 11 | |
| 70 | 3 | 0.4% |
| 80 | 12 | |
| 90 | 20 | |
| 100 | 15 | |
| 101 | 3 | 0.4% |
| 110 | 10 | |
| 111 | 8 | 1.0% |
| 120 | 5 | 0.6% |
| 130 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 199768 | 1 | |
| 162513 | 1 | |
| 134673 | 1 | |
| 38215 | 1 | |
| 37821 | 1 | |
| 37542 | 2 | |
| 37193 | 1 | |
| 37192 | 1 | |
| 36939 | 2 | |
| 33489 | 1 |
0.512 - 1 Mbps
Real number (ℝ)
ZEROS
| Distinct | 633 |
|---|---|
| Distinct (%) | 75.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10374.468 |
| Minimum | 0 |
|---|---|
| Maximum | 171244 |
| Zeros | 50 |
| Zeros (%) | 6.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1347 |
| median | 3760.5 |
| Q3 | 8328.25 |
| 95-th percentile | 51430.4 |
| Maximum | 171244 |
| Range | 171244 |
| Interquartile range (IQR) | 6981.25 |
Descriptive statistics
| Standard deviation | 21587.794 |
|---|---|
| Coefficient of variation (CV) | 2.080858 |
| Kurtosis | 17.521511 |
| Mean | 10374.468 |
| Median Absolute Deviation (MAD) | 2767.5 |
| Skewness | 3.9664419 |
| Sum | 8714553 |
| Variance | 4.6603286 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 50 | 6.0% |
| 10 | 12 | 1.4% |
| 40 | 10 | 1.2% |
| 2850 | 8 | 1.0% |
| 970 | 8 | 1.0% |
| 1090 | 7 | 0.8% |
| 3270 | 7 | 0.8% |
| 9090 | 6 | 0.7% |
| 1120 | 6 | 0.7% |
| 400 | 5 | 0.6% |
| Other values (623) | 721 |
| Value | Count | Frequency (%) |
| 0 | 50 | |
| 10 | 12 | 1.4% |
| 14 | 1 | 0.1% |
| 20 | 1 | 0.1% |
| 30 | 2 | 0.2% |
| 39 | 1 | 0.1% |
| 40 | 10 | 1.2% |
| 47 | 1 | 0.1% |
| 50 | 3 | 0.4% |
| 60 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 171244 | 1 | |
| 162274 | 1 | |
| 137189 | 1 | |
| 133385 | 1 | |
| 132937 | 1 | |
| 128187 | 1 | |
| 124468 | 1 | |
| 123589 | 1 | |
| 115197 | 1 | |
| 112593 | 1 |
1 - 6 Mbps
Real number (ℝ)
HIGH CORRELATION
| Distinct | 831 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 150969.97 |
| Minimum | 2842 |
|---|---|
| Maximum | 2299705 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 2842 |
|---|---|
| 5-th percentile | 11900.4 |
| Q1 | 28539.25 |
| median | 48834.5 |
| Q3 | 86897.5 |
| 95-th percentile | 727863.25 |
| Maximum | 2299705 |
| Range | 2296863 |
| Interquartile range (IQR) | 58358.25 |
Descriptive statistics
| Standard deviation | 348153.84 |
|---|---|
| Coefficient of variation (CV) | 2.3061132 |
| Kurtosis | 21.09886 |
| Mean | 150969.97 |
| Median Absolute Deviation (MAD) | 25713 |
| Skewness | 4.4592125 |
| Sum | 1.2681477 × 108 |
| Variance | 1.2121109 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 35409 | 3 | 0.4% |
| 14014 | 3 | 0.4% |
| 58588 | 2 | 0.2% |
| 22409 | 2 | 0.2% |
| 28600 | 2 | 0.2% |
| 30727 | 2 | 0.2% |
| 40285 | 2 | 0.2% |
| 47454 | 1 | 0.1% |
| 404645 | 1 | 0.1% |
| 48995 | 1 | 0.1% |
| Other values (821) | 821 |
| Value | Count | Frequency (%) |
| 2842 | 1 | |
| 3107 | 1 | |
| 3179 | 1 | |
| 3576 | 1 | |
| 3678 | 1 | |
| 4386 | 1 | |
| 5018 | 1 | |
| 5312 | 1 | |
| 5366 | 1 | |
| 6038 | 1 |
| Value | Count | Frequency (%) |
| 2299705 | 1 | |
| 2288772 | 1 | |
| 2281524 | 1 | |
| 2279875 | 1 | |
| 2267852 | 1 | |
| 2266948 | 1 | |
| 2253197 | 1 | |
| 2250898 | 1 | |
| 2250445 | 1 | |
| 2214760 | 1 |
6 - 10 Mbps
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 757 |
|---|---|
| Distinct (%) | 90.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33783.187 |
| Minimum | 0 |
|---|---|
| Maximum | 403575 |
| Zeros | 38 |
| Zeros (%) | 4.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 19.5 |
| Q1 | 2967.75 |
| median | 8303.5 |
| Q3 | 29956 |
| 95-th percentile | 190929.05 |
| Maximum | 403575 |
| Range | 403575 |
| Interquartile range (IQR) | 26988.25 |
Descriptive statistics
| Standard deviation | 60759.295 |
|---|---|
| Coefficient of variation (CV) | 1.7985069 |
| Kurtosis | 9.7650201 |
| Mean | 33783.187 |
| Median Absolute Deviation (MAD) | 8143.5 |
| Skewness | 3.0022283 |
| Sum | 28377877 |
| Variance | 3.6916919 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 38 | 4.5% |
| 20 | 12 | 1.4% |
| 110 | 4 | 0.5% |
| 10 | 4 | 0.5% |
| 6550 | 3 | 0.4% |
| 150 | 3 | 0.4% |
| 260 | 2 | 0.2% |
| 26562 | 2 | 0.2% |
| 1915 | 2 | 0.2% |
| 7811 | 2 | 0.2% |
| Other values (747) | 768 |
| Value | Count | Frequency (%) |
| 0 | 38 | |
| 10 | 4 | 0.5% |
| 20 | 12 | 1.4% |
| 30 | 1 | 0.1% |
| 60 | 1 | 0.1% |
| 65 | 1 | 0.1% |
| 69 | 1 | 0.1% |
| 70 | 1 | 0.1% |
| 80 | 2 | 0.2% |
| 90 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 403575 | 1 | |
| 402315 | 1 | |
| 335296 | 1 | |
| 331292 | 1 | |
| 321756 | 1 | |
| 311652 | 1 | |
| 311411 | 1 | |
| 307554 | 1 | |
| 299009 | 1 | |
| 297915 | 1 |
10 - 20 Mbps
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 725 |
|---|---|
| Distinct (%) | 86.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34638.142 |
| Minimum | 0 |
|---|---|
| Maximum | 886678 |
| Zeros | 71 |
| Zeros (%) | 8.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2039.5 |
| median | 7766 |
| Q3 | 24396.5 |
| 95-th percentile | 189469.1 |
| Maximum | 886678 |
| Range | 886678 |
| Interquartile range (IQR) | 22357 |
Descriptive statistics
| Standard deviation | 87389.352 |
|---|---|
| Coefficient of variation (CV) | 2.5229226 |
| Kurtosis | 33.883267 |
| Mean | 34638.142 |
| Median Absolute Deviation (MAD) | 7151 |
| Skewness | 5.2130016 |
| Sum | 29096039 |
| Variance | 7.6368988 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 71 | 8.5% |
| 10 | 5 | 0.6% |
| 50 | 4 | 0.5% |
| 100 | 3 | 0.4% |
| 1190 | 3 | 0.4% |
| 1000 | 3 | 0.4% |
| 1110 | 2 | 0.2% |
| 21452 | 2 | 0.2% |
| 3880 | 2 | 0.2% |
| 5216 | 2 | 0.2% |
| Other values (715) | 743 |
| Value | Count | Frequency (%) |
| 0 | 71 | |
| 10 | 5 | 0.6% |
| 26 | 1 | 0.1% |
| 30 | 1 | 0.1% |
| 38 | 1 | 0.1% |
| 40 | 2 | 0.2% |
| 50 | 4 | 0.5% |
| 70 | 1 | 0.1% |
| 92 | 1 | 0.1% |
| 100 | 3 | 0.4% |
| Value | Count | Frequency (%) |
| 886678 | 1 | |
| 816056 | 1 | |
| 712513 | 1 | |
| 676137 | 1 | |
| 577679 | 1 | |
| 576428 | 1 | |
| 573298 | 1 | |
| 487826 | 1 | |
| 467398 | 1 | |
| 445345 | 1 |
20 - 30 Mbps
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 583 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19442.944 |
| Minimum | 0 |
|---|---|
| Maximum | 949093 |
| Zeros | 104 |
| Zeros (%) | 12.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 190 |
| median | 2214.5 |
| Q3 | 9284 |
| 95-th percentile | 75336.65 |
| Maximum | 949093 |
| Range | 949093 |
| Interquartile range (IQR) | 9094 |
Descriptive statistics
| Standard deviation | 70347.381 |
|---|---|
| Coefficient of variation (CV) | 3.6181445 |
| Kurtosis | 81.69084 |
| Mean | 19442.944 |
| Median Absolute Deviation (MAD) | 2214.5 |
| Skewness | 8.0561923 |
| Sum | 16332073 |
| Variance | 4.948754 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 104 | 12.4% |
| 10 | 24 | 2.9% |
| 50 | 18 | 2.1% |
| 20 | 13 | 1.5% |
| 30 | 8 | 1.0% |
| 40 | 7 | 0.8% |
| 220 | 5 | 0.6% |
| 290 | 5 | 0.6% |
| 130 | 4 | 0.5% |
| 90 | 4 | 0.5% |
| Other values (573) | 648 |
| Value | Count | Frequency (%) |
| 0 | 104 | |
| 10 | 24 | 2.9% |
| 14 | 1 | 0.1% |
| 20 | 13 | 1.5% |
| 30 | 8 | 1.0% |
| 40 | 7 | 0.8% |
| 50 | 18 | 2.1% |
| 53 | 1 | 0.1% |
| 60 | 3 | 0.4% |
| 67 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 949093 | 1 | |
| 897964 | 1 | |
| 576859 | 1 | |
| 536049 | 1 | |
| 502275 | 1 | |
| 483572 | 1 | |
| 480237 | 1 | |
| 437662 | 1 | |
| 365713 | 1 | |
| 296155 | 1 |
>=30 Mbps
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 549 |
|---|---|
| Distinct (%) | 65.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79179.562 |
| Minimum | 0 |
|---|---|
| Maximum | 3618689 |
| Zeros | 112 |
| Zeros (%) | 13.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 882.5 |
| Q3 | 19660.75 |
| 95-th percentile | 322176.4 |
| Maximum | 3618689 |
| Range | 3618689 |
| Interquartile range (IQR) | 19653.75 |
Descriptive statistics
| Standard deviation | 342623.37 |
|---|---|
| Coefficient of variation (CV) | 4.3271694 |
| Kurtosis | 55.885917 |
| Mean | 79179.562 |
| Median Absolute Deviation (MAD) | 882.5 |
| Skewness | 6.9897988 |
| Sum | 66510832 |
| Variance | 1.1739078 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 112 | 13.3% |
| 2 | 39 | 4.6% |
| 1 | 19 | 2.3% |
| 3 | 15 | 1.8% |
| 4 | 14 | 1.7% |
| 10 | 13 | 1.5% |
| 5 | 9 | 1.1% |
| 22 | 8 | 1.0% |
| 13 | 8 | 1.0% |
| 9 | 7 | 0.8% |
| Other values (539) | 596 |
| Value | Count | Frequency (%) |
| 0 | 112 | |
| 1 | 19 | 2.3% |
| 2 | 39 | 4.6% |
| 3 | 15 | 1.8% |
| 4 | 14 | 1.7% |
| 5 | 9 | 1.1% |
| 6 | 1 | 0.1% |
| 7 | 6 | 0.7% |
| 8 | 5 | 0.6% |
| 9 | 7 | 0.8% |
| Value | Count | Frequency (%) |
| 3618689 | 1 | |
| 3535757 | 1 | |
| 3381049 | 1 | |
| 3259793 | 1 | |
| 2482266 | 1 | |
| 2337604 | 1 | |
| 2246313 | 1 | |
| 2176242 | 1 | |
| 2085815 | 1 | |
| 1894466 | 1 |
Otros
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 314 |
|---|---|
| Distinct (%) | 37.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4898.2167 |
| Minimum | -1945 |
|---|---|
| Maximum | 120464 |
| Zeros | 455 |
| Zeros (%) | 54.2% |
| Negative | 2 |
| Negative (%) | 0.2% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | -1945 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 5094 |
| 95-th percentile | 21789.6 |
| Maximum | 120464 |
| Range | 122409 |
| Interquartile range (IQR) | 5094 |
Descriptive statistics
| Standard deviation | 12102.988 |
|---|---|
| Coefficient of variation (CV) | 2.4708969 |
| Kurtosis | 42.893262 |
| Mean | 4898.2167 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.690676 |
| Sum | 4114502 |
| Variance | 1.4648233 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 455 | |
| 2151 | 6 | 0.7% |
| 1035 | 6 | 0.7% |
| 6105 | 5 | 0.6% |
| 268 | 3 | 0.4% |
| 4641 | 3 | 0.4% |
| 36917 | 3 | 0.4% |
| 3719 | 3 | 0.4% |
| 45 | 3 | 0.4% |
| 6980 | 3 | 0.4% |
| Other values (304) | 350 |
| Value | Count | Frequency (%) |
| -1945 | 1 | 0.1% |
| -10 | 1 | 0.1% |
| 0 | 455 | |
| 10 | 1 | 0.1% |
| 20 | 2 | 0.2% |
| 30 | 1 | 0.1% |
| 45 | 3 | 0.4% |
| 65 | 2 | 0.2% |
| 168 | 1 | 0.1% |
| 190 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 120464 | 1 | |
| 114182 | 1 | |
| 113357 | 1 | |
| 105818 | 1 | |
| 105607 | 1 | |
| 105477 | 1 | |
| 65849 | 1 | |
| 65821 | 1 | |
| 43573 | 1 | |
| 43438 | 1 |
Total
Real number (ℝ)
HIGH CORRELATION
| Distinct | 834 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 343988.81 |
| Minimum | 12406 |
|---|---|
| Maximum | 4721668 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 12406 |
|---|---|
| 5-th percentile | 25701.75 |
| Q1 | 52328.25 |
| median | 104333 |
| Q3 | 177579.75 |
| 95-th percentile | 1417583.7 |
| Maximum | 4721668 |
| Range | 4709262 |
| Interquartile range (IQR) | 125251.5 |
Descriptive statistics
| Standard deviation | 737336.59 |
|---|---|
| Coefficient of variation (CV) | 2.1434901 |
| Kurtosis | 14.711416 |
| Mean | 343988.81 |
| Median Absolute Deviation (MAD) | 56426 |
| Skewness | 3.7617998 |
| Sum | 2.889506 × 108 |
| Variance | 5.4366524 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 14029 | 3 | 0.4% |
| 35710 | 3 | 0.4% |
| 68538 | 2 | 0.2% |
| 33772 | 2 | 0.2% |
| 177477 | 1 | 0.1% |
| 27032 | 1 | 0.1% |
| 88854 | 1 | 0.1% |
| 80197 | 1 | 0.1% |
| 637473 | 1 | 0.1% |
| 88093 | 1 | 0.1% |
| Other values (824) | 824 |
| Value | Count | Frequency (%) |
| 12406 | 1 | |
| 12557 | 1 | |
| 12741 | 1 | |
| 13040 | 1 | |
| 13055 | 1 | |
| 13147 | 1 | |
| 13220 | 1 | |
| 13302 | 1 | |
| 13488 | 1 | |
| 13660 | 1 |
| Value | Count | Frequency (%) |
| 4721668 | 1 | |
| 4667183 | 1 | |
| 4555424 | 1 | |
| 4509157 | 1 | |
| 4251609 | 1 | |
| 4132351 | 1 | |
| 4060002 | 1 | |
| 4033261 | 1 | |
| 3971683 | 1 | |
| 3937277 | 1 |
Total2
Real number (ℝ)
HIGH CORRELATION
| Distinct | 834 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 336184.93 |
| Minimum | 12656 |
|---|---|
| Maximum | 4667183 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | 12656 |
|---|---|
| 5-th percentile | 26889.05 |
| Q1 | 56000.25 |
| median | 105095.5 |
| Q3 | 177889.5 |
| 95-th percentile | 1402587.6 |
| Maximum | 4667183 |
| Range | 4654527 |
| Interquartile range (IQR) | 121889.25 |
Descriptive statistics
| Standard deviation | 714290.17 |
|---|---|
| Coefficient of variation (CV) | 2.1246942 |
| Kurtosis | 15.316865 |
| Mean | 336184.93 |
| Median Absolute Deviation (MAD) | 55123 |
| Skewness | 3.8188969 |
| Sum | 2.8239534 × 108 |
| Variance | 5.1021044 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 38419 | 3 | 0.4% |
| 14146 | 3 | 0.4% |
| 41890 | 2 | 0.2% |
| 115843 | 2 | 0.2% |
| 96483 | 1 | 0.1% |
| 90573 | 1 | 0.1% |
| 83806 | 1 | 0.1% |
| 611481 | 1 | 0.1% |
| 88228 | 1 | 0.1% |
| 178798 | 1 | 0.1% |
| Other values (824) | 824 |
| Value | Count | Frequency (%) |
| 12656 | 1 | |
| 12912 | 1 | |
| 13072 | 1 | |
| 13127 | 1 | |
| 13139 | 1 | |
| 13237 | 1 | |
| 13346 | 1 | |
| 13428 | 1 | |
| 13605 | 1 | |
| 13777 | 1 |
| Value | Count | Frequency (%) |
| 4667183 | 1 | |
| 4609897 | 1 | |
| 4531772 | 1 | |
| 4509157 | 1 | |
| 4251609 | 1 | |
| 4132351 | 1 | |
| 4033261 | 1 | |
| 3870807 | 1 | |
| 3843534 | 1 | |
| 3777546 | 1 |
Diferencia
Real number (ℝ)
ZEROS
| Distinct | 583 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7803.8786 |
| Minimum | -25884 |
|---|---|
| Maximum | 665118 |
| Zeros | 40 |
| Zeros (%) | 4.8% |
| Negative | 622 |
| Negative (%) | 74.0% |
| Memory size | 6.7 KiB |
Quantile statistics
| Minimum | -25884 |
|---|---|
| 5-th percentile | -10145.7 |
| Q1 | -4657.5 |
| median | -1071 |
| Q3 | 0 |
| 95-th percentile | 42969.55 |
| Maximum | 665118 |
| Range | 691002 |
| Interquartile range (IQR) | 4657.5 |
Descriptive statistics
| Standard deviation | 53295.323 |
|---|---|
| Coefficient of variation (CV) | 6.8293378 |
| Kurtosis | 64.788984 |
| Mean | 7803.8786 |
| Median Absolute Deviation (MAD) | 2502 |
| Skewness | 7.4015179 |
| Sum | 6555258 |
| Variance | 2.8403914 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 40 | 4.8% |
| -513 | 6 | 0.7% |
| -423 | 6 | 0.7% |
| -2709 | 6 | 0.7% |
| 999 | 5 | 0.6% |
| -3717 | 5 | 0.6% |
| -162 | 5 | 0.6% |
| -666 | 5 | 0.6% |
| -504 | 5 | 0.6% |
| -117 | 5 | 0.6% |
| Other values (573) | 752 |
| Value | Count | Frequency (%) |
| -25884 | 1 | |
| -24579 | 1 | |
| -24120 | 1 | |
| -19278 | 1 | |
| -19017 | 1 | |
| -16920 | 1 | |
| -16740 | 1 | |
| -16677 | 1 | |
| -16641 | 1 | |
| -16587 | 1 |
| Value | Count | Frequency (%) |
| 665118 | 1 | |
| 563562 | 1 | |
| 471186 | 1 | |
| 419490 | 1 | |
| 407313 | 1 | |
| 406548 | 1 | |
| 372861 | 1 | |
| 301626 | 1 | |
| 269469 | 1 | |
| 247102 | 1 |
| Año | id_Provincia | <0.512 mbps | 0.512 - 1 Mbps | 1 - 6 Mbps | 6 - 10 Mbps | 10 - 20 Mbps | 20 - 30 Mbps | >=30 Mbps | Otros | Total | Total2 | Diferencia | Trimestre | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Año | 1.000 | 0.000 | -0.088 | -0.325 | -0.137 | 0.337 | 0.412 | 0.582 | 0.711 | 0.735 | 0.302 | 0.298 | 0.010 | 0.000 |
| id_Provincia | 0.000 | 1.000 | -0.256 | -0.248 | -0.187 | -0.255 | -0.326 | -0.273 | -0.283 | 0.011 | -0.235 | -0.229 | -0.171 | 0.000 |
| <0.512 mbps | -0.088 | -0.256 | 1.000 | 0.391 | 0.433 | 0.299 | 0.261 | 0.248 | 0.215 | 0.059 | 0.410 | 0.427 | -0.092 | 0.000 |
| 0.512 - 1 Mbps | -0.325 | -0.248 | 0.391 | 1.000 | 0.410 | 0.332 | 0.272 | 0.119 | 0.039 | -0.163 | 0.311 | 0.324 | -0.022 | 0.000 |
| 1 - 6 Mbps | -0.137 | -0.187 | 0.433 | 0.410 | 1.000 | 0.452 | 0.420 | 0.287 | 0.326 | -0.024 | 0.763 | 0.766 | 0.176 | 0.000 |
| 6 - 10 Mbps | 0.337 | -0.255 | 0.299 | 0.332 | 0.452 | 1.000 | 0.750 | 0.654 | 0.661 | 0.294 | 0.730 | 0.734 | 0.149 | 0.000 |
| 10 - 20 Mbps | 0.412 | -0.326 | 0.261 | 0.272 | 0.420 | 0.750 | 1.000 | 0.742 | 0.773 | 0.340 | 0.738 | 0.743 | 0.164 | 0.000 |
| 20 - 30 Mbps | 0.582 | -0.273 | 0.248 | 0.119 | 0.287 | 0.654 | 0.742 | 1.000 | 0.793 | 0.517 | 0.668 | 0.666 | 0.117 | 0.000 |
| >=30 Mbps | 0.711 | -0.283 | 0.215 | 0.039 | 0.326 | 0.661 | 0.773 | 0.793 | 1.000 | 0.577 | 0.725 | 0.719 | 0.203 | 0.000 |
| Otros | 0.735 | 0.011 | 0.059 | -0.163 | -0.024 | 0.294 | 0.340 | 0.517 | 0.577 | 1.000 | 0.340 | 0.339 | 0.010 | 0.000 |
| Total | 0.302 | -0.235 | 0.410 | 0.311 | 0.763 | 0.730 | 0.738 | 0.668 | 0.725 | 0.340 | 1.000 | 0.994 | 0.255 | 0.000 |
| Total2 | 0.298 | -0.229 | 0.427 | 0.324 | 0.766 | 0.734 | 0.743 | 0.666 | 0.719 | 0.339 | 0.994 | 1.000 | 0.178 | 0.000 |
| Diferencia | 0.010 | -0.171 | -0.092 | -0.022 | 0.176 | 0.149 | 0.164 | 0.117 | 0.203 | 0.010 | 0.255 | 0.178 | 1.000 | 0.000 |
| Trimestre | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Año | Trimestre | id_Provincia | <0.512 mbps | 0.512 - 1 Mbps | 1 - 6 Mbps | 6 - 10 Mbps | 10 - 20 Mbps | 20 - 30 Mbps | >=30 Mbps | Otros | Total | Total2 | Diferencia | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022 | 3 | 0 | 29985 | 27709 | 290315 | 297915 | 267044 | 12419 | 3618689 | 65821 | 4721668 | 4609897 | 111771 |
| 1 | 2022 | 3 | 1 | 5170 | 5742 | 34371 | 67829 | 51946 | 28692 | 1253105 | 105477 | 1547679 | 1552332 | -4653 |
| 2 | 2022 | 3 | 2 | 710 | 3840 | 3107 | 5389 | 5099 | 3737 | 50298 | 2208 | 70293 | 74388 | -4095 |
| 3 | 2022 | 3 | 3 | 4610 | 9870 | 16782 | 18938 | 8049 | 15828 | 79390 | 3711 | 144146 | 157178 | -13032 |
| 4 | 2022 | 3 | 4 | 1090 | 1444 | 45707 | 3094 | 34682 | 15309 | 17563 | 20024 | 165778 | 138913 | 26865 |
| 5 | 2022 | 3 | 5 | 990 | 11312 | 153324 | 111615 | 70989 | 27112 | 650344 | 13873 | 1038668 | 1039559 | -891 |
| 6 | 2022 | 3 | 6 | 670 | 3865 | 23427 | 23948 | 7776 | 21706 | 56950 | 7107 | 144846 | 145449 | -603 |
| 7 | 2022 | 3 | 7 | 1070 | 5549 | 47210 | 46855 | 18263 | 32021 | 102195 | 16759 | 268959 | 269922 | -963 |
| 8 | 2022 | 3 | 8 | 970 | 3070 | 23538 | 19545 | 6194 | 5640 | 17704 | 5890 | 68538 | 82551 | -14013 |
| 9 | 2022 | 3 | 9 | 580 | 1879 | 19135 | 15254 | 36083 | 5190 | 45895 | 0 | 118823 | 124016 | -5193 |
| Año | Trimestre | id_Provincia | <0.512 mbps | 0.512 - 1 Mbps | 1 - 6 Mbps | 6 - 10 Mbps | 10 - 20 Mbps | 20 - 30 Mbps | >=30 Mbps | Otros | Total | Total2 | Diferencia | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830 | 2014 | 1 | 14 | 4133 | 9870 | 77148 | 840 | 1582 | 20 | 22 | 0 | 83958 | 93615 | -9657 |
| 831 | 2014 | 1 | 15 | 467 | 4618 | 84304 | 730 | 1062 | 10 | 8 | 0 | 94736 | 91199 | 3537 |
| 832 | 2014 | 1 | 16 | 530 | 19677 | 64061 | 7192 | 3140 | 0 | 0 | 0 | 91297 | 94600 | -3303 |
| 833 | 2014 | 1 | 17 | 5310 | 20 | 51056 | 0 | 0 | 0 | 0 | 0 | 51589 | 56386 | -4797 |
| 834 | 2014 | 1 | 18 | 70 | 30 | 12544 | 0 | 10 | 0 | 2 | 0 | 12557 | 12656 | -99 |
| 835 | 2014 | 1 | 19 | 1610 | 1625 | 24972 | 10 | 10 | 0 | 0 | 0 | 26760 | 28227 | -1467 |
| 836 | 2014 | 1 | 20 | 8456 | 124468 | 345225 | 20328 | 6845 | 230 | 668 | 0 | 506013 | 506220 | -207 |
| 837 | 2014 | 1 | 21 | 1234 | 10531 | 22817 | 2422 | 1090 | 0 | 0 | 0 | 37113 | 38094 | -981 |
| 838 | 2014 | 1 | 22 | 120 | 6070 | 30902 | 60 | 0 | 0 | 0 | 0 | 31527 | 37152 | -5625 |
| 839 | 2014 | 1 | 23 | 60 | 34672 | 83210 | 11779 | 3620 | 30 | 0 | 0 | 130032 | 133371 | -3339 |